package com.example.project3.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.project3.entity.Tasks;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author 23931
 * @description 针对表【tasks】的数据库操作Mapper
 * @createDate 2023-05-29 15:49:00
 * @Entity com.example.project3.entity.Tasks
 */
@Mapper
public interface TasksMapper extends BaseMapper<Tasks> {

    @Select("select * from worker w,tasks t,user u where t.task_id = w.task_id and u.uid = w.uid and w.uid = #{uid}")
    List<Tasks> selectUserTasks(Integer uid);

}




